/*
 Navicat Premium Data Transfer

 Source Server         : mac
 Source Server Type    : MySQL
 Source Server Version : 80029 (8.0.29)
 Source Host           : localhost:3306
 Source Schema         : stock-replay

 Target Server Type    : MySQL
 Target Server Version : 80029 (8.0.29)
 File Encoding         : 65001

 Date: 11/12/2023 17:23:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_company
-- ----------------------------
DROP TABLE IF EXISTS `t_company`;
CREATE TABLE `t_company` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  `ext_info` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_company
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_dashboard
-- ----------------------------
DROP TABLE IF EXISTS `t_dashboard`;
CREATE TABLE `t_dashboard` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `exponent` double DEFAULT NULL COMMENT '上证指数',
  `trend` int DEFAULT NULL COMMENT '趋势 1上涨  2下跌  3平盘',
  `diff_exponent` double DEFAULT NULL COMMENT '涨跌幅',
  `diff_percent` double DEFAULT NULL COMMENT '涨跌百分比 单位%',
  `rise_num` int DEFAULT NULL COMMENT '上涨数',
  `fail_num` int DEFAULT NULL COMMENT '下跌数',
  `flat_num` int DEFAULT NULL COMMENT '平盘数',
  `limit_up_num` int DEFAULT NULL COMMENT '涨停数',
  `limit_down_num` int DEFAULT NULL COMMENT '跌停数',
  `foreign_value` double NOT NULL COMMENT '外资流入流出资金 单位 亿',
  `foreign_trend` int DEFAULT NULL COMMENT '外资趋势 0平盘 1流入 2流出',
  `main_value` double DEFAULT NULL COMMENT '主力流入流出资金 单位 亿',
  `main_trend` int DEFAULT NULL COMMENT '主力趋势 0平盘 1流入 2流出',
  `total_volume` double DEFAULT NULL COMMENT '成交额 单位 亿',
  `note` varchar(255) COLLATE utf8mb4_0900_bin NOT NULL COMMENT '行情回顾',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_dashboard
-- ----------------------------
BEGIN;
INSERT INTO `t_dashboard` (`id`, `date`, `exponent`, `trend`, `diff_exponent`, `diff_percent`, `rise_num`, `fail_num`, `flat_num`, `limit_up_num`, `limit_down_num`, `foreign_value`, `foreign_trend`, `main_value`, `main_trend`, `total_volume`, `note`, `create_time`, `update_time`, `deleted`) VALUES (1, '2023-12-06', 3001, 1, 62, 0.14, 1, 1000, 21, 15, 10, 25, 1, 23, 1, 1233, 'aaaaa', '2023-12-06 18:07:45', '2023-12-06 18:07:45', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_dragon
-- ----------------------------
DROP TABLE IF EXISTS `t_dragon`;
CREATE TABLE `t_dragon` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL COMMENT '日期',
  `name` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL COMMENT '股票名称',
  `range_percent` double DEFAULT NULL COMMENT '涨跌幅 单位 %',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  `ext_info` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_dragon
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_dragon_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_dragon_detail`;
CREATE TABLE `t_dragon_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dragon_id` int DEFAULT NULL,
  `seat_id` int DEFAULT NULL COMMENT '席位id',
  `buy_amount` double DEFAULT NULL COMMENT '买额 单位 万',
  `sell_amount` double DEFAULT NULL COMMENT '卖额 单位万',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  `ext_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_dragon_detail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_industry
-- ----------------------------
DROP TABLE IF EXISTS `t_industry`;
CREATE TABLE `t_industry` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `ext_info` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_industry
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_industry_company
-- ----------------------------
DROP TABLE IF EXISTS `t_industry_company`;
CREATE TABLE `t_industry_company` (
  `id` int NOT NULL AUTO_INCREMENT,
  `industry_id` int DEFAULT NULL,
  `company_Id` int DEFAULT NULL,
  `is_cock` int DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  `ext_info` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_industry_company
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_limit_up
-- ----------------------------
DROP TABLE IF EXISTS `t_limit_up`;
CREATE TABLE `t_limit_up` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `quantity` int DEFAULT NULL COMMENT '放量1 缩量2 平量3',
  `increase_range` double DEFAULT NULL COMMENT '涨幅 单位 %',
  `market_value` double DEFAULT NULL COMMENT '流通市值，单位 亿',
  `volume` double DEFAULT NULL COMMENT '成交额 单位 万',
  `turnover_rate` double DEFAULT NULL COMMENT '换手率 单位 %',
  `limit_time` time DEFAULT NULL COMMENT '封板时间',
  `last_limit_time` time DEFAULT NULL COMMENT '最后封板时间',
  `bomb_count` int DEFAULT NULL COMMENT '炸板次数',
  `stat` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL COMMENT '涨停统计 几天几板',
  `continuous_count` int DEFAULT NULL COMMENT '连板数',
  `logic` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL COMMENT '涨停逻辑',
  `tag_id` int DEFAULT NULL COMMENT '板块/概念 标签id',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  `ext_info` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_limit_up
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_seat
-- ----------------------------
DROP TABLE IF EXISTS `t_seat`;
CREATE TABLE `t_seat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nick_name` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  `seat_name` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL COMMENT '席位名称',
  `description` text COLLATE utf8mb4_0900_bin COMMENT '操盘风格',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  `ext_info` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_seat
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_tag
-- ----------------------------
DROP TABLE IF EXISTS `t_tag`;
CREATE TABLE `t_tag` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL COMMENT '标签名字',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT NULL,
  `ext_info` varchar(255) COLLATE utf8mb4_0900_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;

-- ----------------------------
-- Records of t_tag
-- ----------------------------
BEGIN;
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (1, '计算机设', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (2, '水泥建材', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (3, '燃气', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (4, '汽车服务', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (5, '纺织服装', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (6, '汽车零部', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (7, '消费电子', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (8, '文化传媒', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (9, '美容护理', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (10, '游戏', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (11, '专用设备', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (12, '石油行业', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (13, '互联网服', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (14, '光学光电', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (15, '通信设备', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (16, '化肥行业', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (17, '装修装饰', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (18, '商业百货', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (19, '工程建设', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (20, '多元金融', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (21, '证券', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (22, '房地产开', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
INSERT INTO `t_tag` (`id`, `name`, `create_time`, `update_time`, `deleted`, `ext_info`) VALUES (23, '家用轻工', '2023-12-11 17:20:15', '2023-12-11 17:20:15', 0, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
